<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body><table id="top_location_line" width="100%"><table id="top_location_line" width="100%"><tr width="100%"><td><a href="http://www.urchin.com"><img border="0" src="../images/google_sm.gif" width="135" height="41"></a></td><td width="100%"><span id="top_line" style="width: 100%; float: left; clear: both; border-bottom: 1px solid #CCC;"><span id="top_title" style="float: left; margin-top: 10px;"><b>Help Center</b></span></td></tr></table>
<div id="page" lang="en" dir="ltr">
<div dir="ltr" id="content" lang="en">
<p class="line867"><strong>Tables v1</strong> <p class="line867"><a href="Data_API.html">API Table of Contents</a> <div><table><tbody><tr>  <td><p class="line891"><strong>Table ID</strong> </td>
  <td><p class="line891"><strong>Dimension for query</strong> </td>
  <td><p class="line891"><strong>Metrics for query</strong> </td>
  <td><p class="line891"><strong>Description</strong> </td>
</tr>
<tr>  <td><p class="line862">1 </td>
  <td><p class="line862">utm_source, utm_medium, utm_campaign, utm_term, request_stem </td>
  <td><p class="line862"> pages, visits, transactions, revenue, responses, impressions, clicks, cost, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">Marketing Campaign results </td>
</tr>
<tr>  <td><p class="line862">2 </td>
  <td><p class="line862">   utm_source, utm_medium, utm_term, utm_content </td>
  <td><p class="line862">pages, visits, transactions, revenue, responses, impressions, clicks, cost, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">Marketing Keyword Conversion and Ad Version information </td>
</tr>
<tr>  <td><p class="line862">3 </td>
  <td><p class="line862">  geo_country, geo_region, geo_city, geo_latitude, geo_longitude </td>
  <td><p class="line862">pages, visits, transactions, revenue, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">Visitor Geo Location information such as Country, Region, City, Latitude and Longitude </td>
</tr>
<tr>  <td><p class="line862"> 4 </td>
  <td><p class="line862"> geo_organization </td>
  <td><p class="line862">pages, visits, transactions, revenue, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">Visitor Organization information. </td>
</tr>
<tr>  <td><p class="line862">5 </td>
  <td><p class="line862">  domain_complete, domain_primary </td>
  <td><p class="line862">pages, visits, transactions, revenue, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">metrics by ISP domain  determined by user IP address </td>
</tr>
<tr>  <td><p class="line862">6 </td>
  <td><p class="line862">  utm_language </td>
  <td><p class="line862">pages, visits, transactions, revenue, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">metrics by browser language code setting. </td>
</tr>
<tr>  <td><p class="line862">7 </td>
  <td><p class="line862">  browser_base, browser_version, platform_base, platform_version, geo_connection_speed </td>
  <td><p class="line862">visits </td>
  <td><p class="line862">Browser, Platform and Visitor Connection Speed information. </td>
</tr>
<tr>  <td><p class="line862">8 </td>
  <td><p class="line862">  utm_screen_resolution, utm_screen_colors, utm_java_enabled, utm_js_version, utm_flash_version </td>
  <td><p class="line862">visits </td>
  <td><p class="line862">Screen resolution and color depth, Javascript and Flash version for visitor. </td>
</tr>
<tr>  <td><p class="line862">9 </td>
  <td><p class="line862">  username </td>
  <td><p class="line862">pages, visits, transactions, revenue, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">        metrics by username (if any) </td>
</tr>
<tr>  <td><p class="line862">10 </td>
  <td><p class="line862"> user_defined_variable </td>
  <td><p class="line862">pages, visits, transactions, revenue, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">metrics by arbitrary segment variable value </td>
</tr>
<tr>  <td><p class="line862">11 </td>
  <td><p class="line862"> visitor_type </td>
  <td><p class="line862">pages, visits, transactions, revenue, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862"> New and Returning visitors. </td>
</tr>
<tr>  <td><p class="line862">12 </td>
  <td><p class="line862"> request_stem, utm_page_title </td>
  <td><p class="line862">pages, entrancepages, exitpages, bouncepages, pagetime, visits, score </td>
  <td><p class="line862">Pages &amp; Files </td>
</tr>
<tr>  <td><p class="line862">13 </td>
  <td><p class="line862"> request_stem, request_query </td>
  <td><p class="line862">pages </td>
  <td><p class="line862">    Pages &amp; Files </td>
</tr>
<tr>  <td><p class="line862">14 </td>
  <td><p class="line862"> clickthru_page_from, clickthru_page_to </td>
  <td><p class="line862">pages, transactions, revenue, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">Goals &amp; Funnel Process information </td>
</tr>
<tr>  <td><p class="line862">15 </td>
  <td><p class="line862"> initial_path_page1, initial_path_page2, initial_path_page3 </td>
  <td><p class="line862">visits, transactions, revenue, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">Goals &amp; Funnel Process information </td>
</tr>
<tr>  <td><p class="line862">16 </td>
  <td><p class="line862"> goal_clickthru_entrance_page, goal_clickthru_exit_page </td>
  <td><p class="line862">visits </td>
  <td><p class="line862"> Defined Funnel Navigation information </td>
</tr>
<tr>  <td><p class="line862">17 </td>
  <td><p class="line862"> rev_goal_path, rev_goal_path_page1, rev_goal_path_page2, rev_goal_path_page3 </td>
  <td><p class="line862">goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">Reverse Goal Path information </td>
</tr>
<tr>  <td><p class="line862">18 </td>
  <td><p class="line862"> utm_campaign_goal </td>
  <td><p class="line862">goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">Goal Tracking information </td>
</tr>
<tr>  <td><p class="line862">19 </td>
  <td><p class="line862"> utm_term, utm_campaign_hour </td>
  <td><p class="line862">transactions, revenue, responses, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">Goal Conversion information </td>
</tr>
<tr>  <td><p class="line862">20 </td>
  <td><p class="line862"> ecommerce_bill_country, ecommerce_bill_region, ecommerce_bill_city </td>
  <td><p class="line862">transactions, revenue </td>
  <td><p class="line862">Billing information for e-commerce transactions </td>
</tr>
<tr>  <td><p class="line862">21 </td>
  <td><p class="line862"> ecommerce_affiliation </td>
  <td><p class="line862">transactions, revenue </td>
  <td><p class="line862">affiliate marketing information for e-commerce transactions </td>
</tr>
<tr>  <td><p class="line862">22 </td>
  <td><p class="line862"> ecommerce_product_name, ecommerce_product_code, ecommerce_variation </td>
  <td><p class="line862">transactions, items, itemrevenue </td>
  <td><p class="line862">Product information for e-commerce transactions </td>
</tr>
<tr>  <td><p class="line862">23 </td>
  <td><p class="line862"> ecommerce_product_name, ecommerce_bill_country, ecommerce_bill_region, ecommerce_bill_city </td>
  <td><p class="line862">transactions, items, itemrevenue </td>
  <td><p class="line862">Product City,Region,Country Correlation information for e-commerce transactions </td>
</tr>
<tr>  <td><p class="line862">24 </td>
  <td><p class="line862"> ecommerce_product_name, utm_source, utm_medium, utm_term </td>
  <td><p class="line862">transactions, items, itemrevenue </td>
  <td><p class="line862">Product Keyword, Source, Medium Correlation and Referring Sources informations for e-commerce transactions. </td>
</tr>
<tr>  <td><p class="line862">25 </td>
  <td><p class="line862"> utm_request_hostname </td>
  <td><p class="line862">pages </td>
  <td><p class="line862">Host names of the compaign hit. </td>
</tr>
<tr>  <td><p class="line862">26 </td>
  <td><p class="line862"> domain_complete, domain_primary, client_ipaddress </td>
  <td><p class="line862">hits, bytes </td>
  <td><p class="line862">ISP domain information determined by user IP address; number of hits and  bytes transferred. </td>
</tr>
<tr>  <td><p class="line862">27 </td>
  <td><p class="line862"> browser_base, browser_version, platform_base, platform_version, geo_connection_speed </td>
  <td><p class="line862">hits, bytes </td>
  <td><p class="line862"> Browser, Platform, Visitor Connection Speed, hits and bytes transferred. </td>
</tr>
<tr>  <td><p class="line862">28 </td>
  <td><p class="line862"> username </td>
  <td><p class="line862">validhits, bytes </td>
  <td><p class="line862">visitors by username (if any), number of  successful hits and bytes transferred. </td>
</tr>
<tr>  <td><p class="line862">29 </td>
  <td><p class="line862"> request_origfilepath, request_origmime </td>
  <td><p class="line862">validhits, bytes </td>
  <td><p class="line862"> Pages &amp; Files; number of successful hits, and number of bytes transferred. </td>
</tr>
<tr>  <td><p class="line862">30 </td>
  <td><p class="line862"> request_download </td>
  <td><p class="line862">validhits, bytes </td>
  <td><p class="line862">list of download requests </td>
</tr>
<tr>  <td><p class="line862">31 </td>
  <td><p class="line862"> request_form </td>
  <td><p class="line862">validhits </td>
  <td><p class="line862">list of requested "posted form". </td>
</tr>
<tr>  <td><p class="line862">32 </td>
  <td><p class="line862"> sc_status </td>
  <td><p class="line862">hits </td>
  <td><p class="line862">return status codes from server </td>
</tr>
<tr>  <td><p class="line862">33 </td>
  <td><p class="line862"> sc_status, request_origfilepath, referral_host, referral_stem, username </td>
  <td><p class="line862">errorhits </td>
  <td><p class="line862">Referral Errors information. </td>
</tr>
<tr>  <td><p class="line862">34 </td>
  <td><p class="line862"> robot_agent, cs_useragent </td>
  <td><p class="line862">validhits, errorhits, bytes </td>
  <td><p class="line862">robot information. </td>
</tr>
<tr>  <td><p class="line862">35 </td>
  <td><p class="line862"> robot_agent, cs_useragent, request_origfilepath </td>
  <td><p class="line862">hits </td>
  <td><p class="line862">robot Content information </td>
</tr>
<tr>  <td><p class="line862">36 </td>
  <td><p class="line862"> log_source_name </td>
  <td><p class="line862">hits, bytes </td>
  <td><p class="line862">list of log source assigned to profile and their information </td>
</tr>
<tr>  <td><p class="line862">37 </td>
  <td><p class="line862"> utm_campaign, cpc_account, cpc_campaign, cpc_adgroup, cpc_keyword </td>
  <td><p class="line862"> pages, visits, transactions, revenue, responses, impressions, clicks, cost, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862"> Advertiser information for UTM campaign </td>
</tr>
<tr>  <td><p class="line862">38 </td>
  <td><p class="line862"> utm_term, cpc_account, cpc_campaign, cpc_adgroup, cpc_keyword </td>
  <td><p class="line862"> pages, visits, transactions, revenue, responses, impressions, clicks, cost, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862"> Advertiser information for UTM term (keyword) </td>
</tr>
<tr>  <td><p class="line862">39 </td>
  <td><p class="line862"> utm_source, utm_medium, utm_campaign, utm_term,utm_content </td>
  <td><p class="line862"> pages, visits, transactions, revenue, responses, impressions, clicks, cost, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862"> ROI reports information </td>
</tr>
<tr>  <td><p class="line862">256 </td>
  <td><p class="line862"> visitor_id </td>
  <td><p class="line862">pages, visits, visitors, transactions, revenue, goals1, goals2, goals3, goals4 </td>
  <td><p class="line862">metrics by visitor id </td>
</tr>
<tr>  <td><p class="line862">257 </td>
  <td><p class="line862"> transaction_id </td>
  <td><p class="line862">transactions, revenue, tax, shipping, items </td>
  <td><p class="line862">metrics by transaction id </td>
</tr>
<tr>  <td><p class="line862">258 </td>
  <td><p class="line862">        totals, month, day, hour </td>
  <td><p class="line862">hits, validhits, errorhits, bytes, pages, nonpages, entrancepages, exitpages, bouncepages, pagetime, visits, visitors, newvisitors, priorvisitors, transactions, customers, newcustomers, priorcustomers, revenue, tax, shipping, items, itemrevenue, responses, impressions, clicks, cost, goals1, goals2, goals3, goals4, goalstarts1, goalstarts2, goalstarts3, avgsessiontime </td>
  <td><p class="line862">aggregates by period (for example monthly, daily, hourly totals). </td>
</tr>
</tbody></table></div></div><div id="pagebottom"></div>
</div>


<div id="footer" style="clear: both; margin: 0; padding: 0; border-bottom:1px solid #CCC;"></div><div id="copyright" style="font-size: 70%; text-align: center;">&copy;2010 Google</div>
</body></html>